Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsm_physical_service table — gsmpy

This table maintains the list of supported physical service.

Table 13–11 lists the table’s FLA, fields, and foreign keys.

Table 13–11: gsm_physical_service table information 

Table FLA	Fields (data type)	Foreign keys
gsmpy	physical_service_obj (Decimal) physical_service_code (Character) physical_service_description (Character) service_type_obj (Decimal) connection_parameters (Character)	physical_service_obj service_type_obj

Table 13–12 gives details of the table’s indexes.

Table 13–12: gsm_physical_service index information 

Index name	Elements	Type
XPKgsm_physical_service	physical_service_obj	Primary Unique
XAK1gsm_physical_service	physical_service_code	Unique
XIE1gsm_physical_service	physical_service_description	Nonunique
XIE2gsm_physical_service	service_type_obj	Nonunique

This table provides the specific connection parameters that are required to connect a physical service to a session. A physical service is connected to a logical service and session type by the session service.

The maintenance object on the service type defines the datafield object used to maintain the physical connection parameters attribute. For example, in a database connection service type, the datafield might allow the specification of -S, -N, and -H prompts independently. It can then put the result as a single field into the connection parameters.

In the case of Web services, there are many connection parameters, some of which are only known at run time. To support this, the connection_parameters field supports substitution lists. The substitution list contains token value lists delimited by CHR(1), and the token and value are delimited by CHR(3).

The tokens are %<parameter_name> or a special token, %DynUserID, that is replaced by the Progress Dynamics user id of the current user. For example, tokens can be defined for parameters as follows:

WSDL UserId = %WSDLUserId WSDL Password = %WSDLPassword SOAPEndpoint UserId = %DynUserID SOAPEndpoint Password = %SOAPEndpointPassword MaxConnections = %maxConnections

The management object on the service type is the API procedure that is responsible for making the physical connections to the service.